Jeff M. ✭✭✭

Overview

Overview

Roles	Member
Badges	8

About Me

About Me

Not much happening here, yet.

Analytics

67

Posts

114

Visits

143

Points

Dec 17, 2021

Join Date

May 7, 2022

Last Active

Reactions

• Insightful 6

  6
• Vote Up 3

  3

• Activity
• Discussions
• Comments67

• Re: Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)

  Jeff M.

  02/13/22
  Try creating a helper column "collect reports" in the second sheet next to the parts column and try using this method.. =JOIN(COLLECT({Report Range 1}, {Work Order Range 1}, CONTAINS([R/O #…
  1 ·

• Re: Automation of Daily and Weekly Report

  Jeff M.

  02/13/22
  The report is essentially a live view of data from a single sheet or multiple. If you needed the sheets to update, then you would run the automation in the specific sheet. This can be done weekly and…
  1 ·

• Re: Send A Daily reminder based on Status field

  Jeff M.

  12/17/21
  The Automation 'Alert Someone' with the trigger set to when a date is reached. Then change the setting to custom which allows you to change it to check it daily at a specified hour. Next, the conditi…
  1 ·